2014-05-23 - 12992 - Spec - OLAP Analysis query fixes #BExQueriesforCrystalReportsAnalysisTool
SPECIFICATIONS
12992 - OLAP Analysis query fixes
Purpose
Need to fix the OLAP Anaysis BEx queries and also to create a new OLAP Anlaysis BEx Query on ZMP_OPASA infoprovider.
Admin Info
Purpose
|
Need to fix OLAP Analysis Queries and to create a new BEx Query.
|
Requested By
|
Mark Harris
|
Spec Created By
|
Chandramouli K
|
Spec Created Date
|
05/23/2014
|
Spec QA by
|
Uday Kumar P
|
Objects
|
VMP_OPASA_Q001,VMP_OPASA_Q001 and VMP_OPASA_Q004.
|
Document Status
|
Complete
|
References
Prior Tickets
None
Documents
Attached with related release notes.
Functional Requirement
1. Need to sort all the objects in Alphabetical order for VMP_OPASA_Q001 BEx Query and transport it to BPQ(BW 7.3 Quality).
2. Need to sort all the objects in Alphabetical order for VMP_OPASA_Q002 BEx Query and transport it to BPQ(BW 7.3 Quality).
3. Need to create a new BW BEx Query on ZMP_OPASA in BPD(BW 7.3 Development) and transport it to BPQ(BW 7.3 Quality).
Solution Summary
1. Need to create a open transport request & sort all the objects in alphabetical order for VMP_OPASA_Q001 BEx Query.
2. Need to create a open transport request & sort all the objects in alphabetical order for VMP_OPASA_Q002 BEx Query.
3. Need to create a new BEx Query in BPD(BW 7.3 Development) with required Characteristics, Key Figures and other query properties as per the NEC requirement on ZMP_OPASA infoprovider.
4. Need to test & transport the changes to BPQ(BW 7.3 Quality).
Test Plan
SNo.
|
Test Scenario
|
Expected Results
|
1
|
Check whether all the changes are collected into the respective transport requests.
|
All the changes should be collected into the respective transport requests.
|
2
|
Check if the new BEX Query VMP_OPASA_Q004 against NEC Standard BEx checklist.
|
Query should pass all test cases as per NEC standard checklist.
|
3
|
Checx if all the Objects are sorted correctly in alphabetical order.
|
All the objects must be sorted in Alphabetical order.
|
Solution Details
1. Need to create a open transport request & sort all the objects in alphabetical order in BPD(BW 7.3 Development) for VMP_OPASA_Q001 BEx Query.
2. Need to create a open transport request & sort all the objects in alphabetical order in BPD(BW 7.3 Development) for VMP_OPASA_Q002 BEx Query
3. Need to create a new BEx Query VMP_OPASA_Q004 in BPD(BW 7.3 Development) with required Characteristics, Key Figures and other query properties as per the NEC requirement on ZMP_OPASA infoprovider.
4. Need to test & transport the changes to BPQ(BW 7.3 Quality).
Issues
None